ALTER TABLE XJInspectionPlan ADD MaintenanceTeamId int,MaintenancePersonId int
GO
UPDATE XJInspectionPlan SET MaintenanceTeamId = 0,MaintenancePersonId = 0
GO
ALTER TABLE XJInspectionPlan ALTER COLUMN MaintenanceTeamId int not null
GO
ALTER TABLE XJInspectionPlan ALTER COLUMN MaintenancePersonId int not null
GO